package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiT_bankcard;

//DAO
public interface T_bankcardMapperBase {

	// 根据id查看
	@Select("SELECT * FROM T_BANKCARD  WHERE BANKCARDID = #{BANKCARDID}")
	public ApiT_bankcard findT_bankcardById(Integer bankcardid);

	// 查看数据集
	@Select("SELECT * FROM T_bankcard")
	public List<ApiT_bankcard> findT_bankcards();

	// 添加
	@Insert("INSERT INTO T_BANKCARD (CARDNAME, CARDNO, OPENINGBANK, CREDENTIALSTYPE, CREDENTIALSNO, PHONE, BANKCARDTYPE, U_ID, CREATE_TIME, IS_DELETE,STATUS) VALUES (#{cardname}, #{cardno}, #{openingbank}, #{credentialstype}, #{credentialsno}, #{phone}, #{bankcardtype}, #{u_id}, #{create_time},#{is_delete},#{status})")
	public int insertT_bankcard(ApiT_bankcard t_bankcard);

	// 修改
	@Update("UPDATE T_BANKCARD SET CARDNAME = #{cardname}, CARDNO = #{cardno}, OPENINGBANK = #{openingbank}, CREDENTIALSTYPE = #{credentialstype}, CREDENTIALSNO = #{credentialsno}, PHONE = #{phone}, BANKCARDTYPE = #{bankcardtype}, U_ID = #{u_id}, CTEATE_TIME = #{create_time}, status = #{status}, is_delete = #{is_delete} WHERE bankcardid = #{bankcardid}")
	public int updateT_bankcard(ApiT_bankcard t_bankcard);

	// 删除
	@Delete("DELETE FROM T_BANKCARD  WHERE BANKCARDID = #{bankcardid}")
	public int deleteT_bankcard(Integer bankcardid);

	// Foreign keys revelant

	// region Indexs revelant

}
